package cn.jcby.app.lebu.utils.sql;

/**
 * @author:Administrator
 * @date:2021-10-25
 */
public class CCodelSql {

    public String listByProjectList(){

        return "<script>select t.ccode ccode,t.ccode_fullName ccodeFullName from NE_SubjectMapFullName t left join GL_accvouch b on b.ccode=t.ccode where b.citem_id in " +
                "<foreach collection='list' item='item' index='index' open='(' separator=',' close=')>#{item}</foreach>" +
                " </script> " ;
    }
}
